{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["MSU","MYP, MSS","Arvo-ottelut"],"read":"whole","date_system":"1900"}

{"sheet":"MSU","index":0,"n_rows":28,"n_cols":43,"rows_kept":28}
[null,"Aatu Roivainen",null,null,"22.1.2001   Siilinjärvi"]
[null,"SUPERPESIS",null,null,"Runkosarja",{"$nulls":3},"  Kärkilyönnit (KL),  pesänvälit",{"$nulls":6},"      Runkosarja TOP-30",{"$nulls":4},"Alempi loppusarja",{"$nulls":6},"Ylempi loppusarja TOP-10",{"$nulls":4},"Play off, voitot, voittoprosentti",{"$nulls":4}," Arvo-ottelut",null,null,"      Mitalit"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","0 > 1","1 > 2","2 > 3","3 > k","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"Puolivälierät","Välierät","Pronssi","Finaalit",null,"IL","LL","hSM","K","H","P"]
[null,2015,"8.","SiiPe  2",null,"suomensarja"]
[null,2016,"8.","PKP",null,"suomensarja"]
[null,2017,"7.","PKP",null,"suomensarja"]
[null,2018,"4.","JuNu",null,"suomensarja"]
[null,2018,"2.","SiiPe",null,"ykköspesis",{"$nulls":14},4,0,0,2,6,{"v":0.3157,"d":"31.6 %"},19]
[null,2019,"7.","LU",null,"ykköspesis"]
[null,2019,"13.","SiiPe",1,0,1,1,3,2,0,0,1,{"v":0.375,"d":"37.5 %"},8]
[null,2020,"6.","SiiPe  2",null,"suomensarja"]
[null,2020,"6.","SoJy  2",null,"ykköspesis"]
[null,2020,"14.","SiiPe",8,0,0,2,11,10,0,1,0,{"v":0.2619,"d":"26.2 %"},42]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E13)","v":9},0,1,3,14,12,0,1,1,{"$f":"PRODUCT(I14/O14)","v":{"v":0.28,"d":"28.0 %"}},{"$f":"SUM(O4:O13)","v":50},"0-0-0","0-0-0","0-0-0","0-0-0",null,{"$f":"SUM(U4:U13)","v":4},0,0,2,6,{"v":0.316,"d":"31.6 %"},{"$f":"SUM(AA4:AA13)","v":{"v":19,"d":"1900.0 %"}},"0-0-0","0-0-0","0-0-0","0-0-0",null,"0/0","0/0","0/0","0/0",null,{"$f":"SUM(AL4:AL13)","v":0},0,0,0,0,0]
[{"$nulls":32},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"}]
[null,"Pesispörssi",null,{"$f":"SUM(F14:H14)+((I14-F14-G14)/3)+(E14/3)+(AL14*25)+(AM14*25)+(AN14*10)+(AO14*25)+(AP14*20)+(AQ14*15)","v":{"v":11.333333333333332,"d":"11.3"}}]
[]
[null,"URA SUPERISSA",null,null,"OTT","KUN","LÖI","TOI","KL",null,"ka/L","ka/T","ka/KL","KL-%",null,"ENSIMMÄISET RUNKOSARJASSA"]
[null,"Runkosarja",null,null,{"$f":"PRODUCT(E14)","v":9},{"$f":"PRODUCT(F14)","v":0},{"$f":"PRODUCT(G14)","v":1},{"$f":"PRODUCT(H14)","v":3},{"$f":"PRODUCT(I14)","v":14},null,{"$f":"PRODUCT((F19+G19)/E19)","v":{"v":0.1111111111111111,"d":"0.11"}},{"$f":"PRODUCT(H19/E19)","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"PRODUCT(I19/E19)","v":{"v":1.5555555555555556,"d":"1.56"}},{"$f":"PRODUCT(N14)","v":{"v":0.28,"d":"28.0 %"}},{"$f":"PRODUCT(O14)","v":50},"Ottelu",null,"26.08. 2018  SiiPe - HP  2-0  (2-0, 3-2)",{"$nulls":7},"1.  ottelu",null,null,"  17 v   7 kk   4 pv"]
[null,"Ylempi loppusarja",{"$nulls":13},"Lyöty",null,"09.07. 2019  SiiPe - KPL  0-2  (4-12, 3-4)",{"$nulls":7},"5.  ottelu",null,null,"  18 v   5 kk 17 pv"]
[null,"Alempi loppusarja",null,null,4,0,0,2,6,null,{"$f":"PRODUCT((F21+G21)/E21)","v":{"v":0,"d":"0.00"}},{"$f":"PRODUCT(H21/E21)","v":{"v":0.5,"d":"0.50"}},{"$f":"PRODUCT(I21/E21)","v":{"v":1.5,"d":"1.50"}},{"v":0.316,"d":"31.6 %"},19,"Tuotu",null,"01.09. 2018  SiiPe - HP  2-0  (7-4, 12-5)",{"$nulls":7},"1.  ottelu",null,null,"  17 v   7 kk 10 pv"]
[null,"KAIKKI",null,null,{"$f":"SUM(E19:E21)","v":13},{"$f":"SUM(F19:F21)","v":0},{"$f":"SUM(G19:G21)","v":1},{"$f":"SUM(H19:H21)","v":5},{"$f":"SUM(I19:I21)","v":20},null,{"$f":"PRODUCT((F22+G22)/E22)","v":{"v":0.07692307692307693,"d":"0.08"}},{"$f":"PRODUCT(H22/E22)","v":{"v":0.38461538461538464,"d":"0.38"}},{"$f":"PRODUCT(I22/E22)","v":{"v":1.5384615384615385,"d":"1.54"}},{"$f":"PRODUCT(I22/O22)","v":{"v":0.2898550724637681,"d":"29.0 %"}},{"$f":"SUM(O19:O21)","v":69},"Kunnari"]
[]
[null,"Seurat",null,"SiiPe = Siilinjärven Pesis  (1987),  kasvattajaseura"]
[{"$nulls":3},"PKP = Puurtilan Kisa-Pojat  (1948)"]
[{"$nulls":3},"JuNu = Juvan Nuorisopesis  (2002)"]
[{"$nulls":3},"LU = Laukaan Urheilijat  (1929)"]
[{"$nulls":3},"SoJy = Sotkamon Jymy  (1909)"]

{"sheet":"MYP, MSS","index":1,"n_rows":16,"n_cols":45,"rows_kept":16}
[null,"Aatu Roivainen",null,null,"22.1.2001   Siilinjärvi"]
[null,"YKKÖSPESIS",null,null,"Runkosarja",{"$nulls":6},"    Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat",{"$nulls":6},"SUOMENSARJA",null,null,"Runkosarja",{"$nulls":6},"  Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%"]
[{"$nulls":23},2015,"8.","SiiPe  2",4,0,1,1,6,{"v":0.3529,"d":"35.3 %"},17]
[{"$nulls":23},2016,"8.","PKP",8,0,3,0,19,{"v":0.3877,"d":"38.8 %"},49]
[{"$nulls":23},2017,"7.","PKP",16,0,1,22,62,{"v":0.5438,"d":"54.4 %"},114]
[null,2018,"2.","SiiPe",9,0,3,5,28,{"v":0.56,"d":"56.0 %"},50,{"$nulls":5},3,0,0,0,3,{"v":0.2142,"d":"21.4 %"},14,2018,"4.","JuNu",9,2,0,12,32,{"v":0.5614,"d":"56.1 %"},57]
[null,2019,"7.","LU",20,0,3,3,45,{"v":0.3947,"d":"39.5 %"},114]
[null,2020,"6.","SoJy  2",4,0,0,4,9,{"v":0.2812,"d":"28.1 %"},32,{"$nulls":12},2020,"6.","SiiPe  2",4,0,0,4,15,{"v":0.7142,"d":"71.4 %"},21]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E4:E9)","v":33},{"$f":"SUM(F4:F9)","v":0},{"$f":"SUM(G4:G9)","v":6},{"$f":"SUM(H4:H9)","v":12},{"$f":"SUM(I4:I9)","v":82},{"$f":"PRODUCT(I10/K10)","v":{"v":0.41836734693877553,"d":"41.8 %"}},{"$f":"SUM(K4:K9)","v":196},{"$nulls":5},{"$f":"SUM(Q4:Q9)","v":3},{"$f":"SUM(R4:R9)","v":0},{"$f":"SUM(S4:S9)","v":0},{"$f":"SUM(T4:T9)","v":0},{"$f":"SUM(U4:U9)","v":3},{"$f":"PRODUCT(U10/W10)","v":{"v":0.21428571428571427,"d":"21.4 %"}},{"$f":"SUM(W4:W9)","v":14},"YHTEENSÄ",null,null,{"$f":"SUM(AA4:AA9)","v":41},{"$f":"SUM(AB4:AB9)","v":2},{"$f":"SUM(AC4:AC9)","v":5},{"$f":"SUM(AD4:AD9)","v":39},{"$f":"SUM(AE4:AE9)","v":134},{"$f":"PRODUCT(AE10/AG10)","v":{"v":0.5193798449612403,"d":"51.9 %"}},{"$f":"SUM(AG4:AG9)","v":258},{"$nulls":5},{"$f":"SUM(AM4:AM9)","v":0},{"$f":"SUM(AN4:AN9)","v":0},{"$f":"SUM(AO4:AO9)","v":0},{"$f":"SUM(AP4:AP9)","v":0},{"$f":"SUM(AQ4:AQ9)","v":0},{"v":0,"d":"0.0 %"},{"$f":"SUM(AS4:AS9)","v":0}]
[]
[null,"KAIKKI OTTELUT",null,null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"ka/L","ka/T","ka/l+t","ka/kl",null,null,"Seurat",null,"SiiPe = Siilinjärven Pesis  (1987),  kasvattajaseura"]
[null,"SUPERPESIS",null,null,13,0,1,5,20,{"v":0.29,"d":"29.0 %"},{"$f":"PRODUCT(I13/J13)","v":68.96551724137932},{"$f":"PRODUCT((F13+G13)/E13)","v":{"v":0.07692307692307693,"d":"0.08"}},{"$f":"PRODUCT(H13/E13)","v":{"v":0.38461538461538464,"d":"0.38"}},{"$f":"PRODUCT((F13+G13+H13)/E13)","v":{"v":0.46153846153846156,"d":"0.46"}},{"$f":"PRODUCT(I13/E13)","v":{"v":1.5384615384615385,"d":"1.54"}},{"$nulls":4},"PKP = Puurtilan Kisa-Pojat  (1948)"]
[null,"YKKÖSPESIS",null,null,{"$f":"PRODUCT(E10+Q10)","v":36},{"$f":"PRODUCT(F10+R10)","v":0},{"$f":"PRODUCT(G10+S10)","v":6},{"$f":"PRODUCT(H10+T10)","v":12},{"$f":"PRODUCT(I10+U10)","v":85},{"$f":"PRODUCT(I14/K14)","v":{"v":0.40476190476190477,"d":"40.5 %"}},{"$f":"PRODUCT(K10+W10)","v":210},{"$f":"PRODUCT((F14+G14)/E14)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"PRODUCT(H14/E14)","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"PRODUCT((F14+G14+H14)/E14)","v":{"v":0.5,"d":"0.50"}},{"$f":"PRODUCT(I14/E14)","v":{"v":2.361111111111111,"d":"2.36"}},{"$nulls":4},"JuNu = Juvan Nuorisopesis  (2002)"]
[null,"SUOMENSARJA",null,null,{"$f":"PRODUCT(AA10+AM10)","v":41},{"$f":"PRODUCT(AB10+AN10)","v":2},{"$f":"PRODUCT(AC10+AO10)","v":5},{"$f":"PRODUCT(AD10+AP10)","v":39},{"$f":"PRODUCT(AE10+AQ10)","v":134},{"$f":"PRODUCT(I15/K15)","v":{"v":0.5193798449612403,"d":"51.9 %"}},{"$f":"PRODUCT(AG10+AS10)","v":258},{"$f":"PRODUCT((F15+G15)/E15)","v":{"v":0.17073170731707318,"d":"0.17"}},{"$f":"PRODUCT(H15/E15)","v":{"v":0.9512195121951219,"d":"0.95"}},{"$f":"PRODUCT((F15+G15+H15)/E15)","v":{"v":1.1219512195121952,"d":"1.12"}},{"$f":"PRODUCT(I15/E15)","v":{"v":3.268292682926829,"d":"3.27"}},{"$nulls":4},"LU = Laukaan Urheilijat  (1929)"]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E13:E15)","v":90},{"$f":"SUM(F13:F15)","v":2},12,56,239,{"$f":"PRODUCT(I16/K16)","v":{"v":0.4450937580272284,"d":"44.5 %"}},{"$f":"SUM(K13:K15)","v":536.9655172413793},{"$f":"PRODUCT((F16+G16)/E16)","v":{"v":0.15555555555555556,"d":"0.16"}},{"$f":"PRODUCT(H16/E16)","v":{"v":0.6222222222222222,"d":"0.62"}},{"$f":"PRODUCT((F16+G16+H16)/E16)","v":{"v":0.7777777777777778,"d":"0.78"}},{"$f":"PRODUCT(I16/E16)","v":{"v":2.6555555555555554,"d":"2.66"}},{"$nulls":4},"SoJy = Sotkamon Jymy  (1909)"]

{"sheet":"Arvo-ottelut","index":2,"n_rows":4,"n_cols":24,"rows_kept":4}
[null," ITÄ - LÄNSI - KORTTI"]
[null,"Aatu Roivainen","22.1.2001   Siilinjärvi"]
[null,"B-POJAT","  Itä - Länsi, tulos","Joukkue","Seura",null,"V","T","H","Up.","Lj.","Palk.","O","K","L","T","KL",1,2,3,"k","KL-%","Pelinjohtaja      "," Yleisöä"]
[null,"05.07. 2019  Seinäjoki","  2-0  (6-3, 3-2)","Itä","SiiPa",null,1,{"$nulls":3},"jok",null,1,null,"1",null,"2/4",null,null,"1/1","1/3",{"v":0.5,"d":"50.0 %"},"Jussi-Pekka Tanskanen",1153]